UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EVJAvEaU3rOkzFB/CNAP7YX/zvRr4sfiE38ZM6CxcI='
WHERE
key_id = '28c842adeba5e1f4ac7553c8d9877f0390daea45e275814a53586d422b72f474'
AND (
token = '4EVJAvEaU3rOkzFB/CNAP7YX/zvRr4sfiE38ZM6CxcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)