UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vV6g9bh4modbGUDYz70eU8tkd3EYcfMZPXCOPbNOiPU='
WHERE
key_id = 'cec49c28454c064584e5dd9100464be49a777b119fc2b77f3666cbdd996305d8'
AND (
token = 'vV6g9bh4modbGUDYz70eU8tkd3EYcfMZPXCOPbNOiPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)