UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sJP9ierMJm2G0lnqbekbGPLQzTLXxQLNYWFreqo4j4U='
WHERE
key_id = '9e13f42dcce24a4668c913067ef34db3af6427dd0234657b814aaa523dd3077b'
AND (
token = 'sJP9ierMJm2G0lnqbekbGPLQzTLXxQLNYWFreqo4j4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)