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