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