UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ty2aDlAzvWYhyyhp6agfeTuXAnLfW8z93wsa3m3rCeE='
WHERE
key_id = '10e390f71d338e7aff697d9bcac4a27c8f6ca29e7b602b288d50de5a86588a6d'
AND (
token = 'ty2aDlAzvWYhyyhp6agfeTuXAnLfW8z93wsa3m3rCeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)