UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pHVjB4RQaesZxgo3z4I0jDMJv28ReUtMu5aCL0/WoE='
WHERE
key_id = 'c1f93e74c2884f363b4ea93be793924cea0fa3a6f796e963721e17bfcf4ed28e'
AND (
token = '3pHVjB4RQaesZxgo3z4I0jDMJv28ReUtMu5aCL0/WoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)