UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qloFZ2oi0Y3p04Tsg4JtaFCjv1Bjdq+w/bxbfcL6HjM='
WHERE
key_id = 'b56918a606022ab70807b6711643f881bd759e235361cc957033c28efb0c176a'
AND (
token = 'qloFZ2oi0Y3p04Tsg4JtaFCjv1Bjdq+w/bxbfcL6HjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)