UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Vr54TP6FrSq9SVzNxs5I360sIof0f6R9u6YvP4GLrE='
WHERE
key_id = '8a926aa544e24353f35d667dd001f028311a08fda4dd8fe00e447c03e111450b'
AND (
token = '0Vr54TP6FrSq9SVzNxs5I360sIof0f6R9u6YvP4GLrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)