UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9rvJ7BnsstRijB0k22Zmlx30Qa/4je8rCn7Uex6G5k='
WHERE
key_id = 'b9e155a36e6b31b547622d1174da48e97dd6d989867a9b7da36ed824a9949631'
AND (
token = 'f9rvJ7BnsstRijB0k22Zmlx30Qa/4je8rCn7Uex6G5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)