UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4dm80Mjr9tPHgvkcuRqwQ1GaS4AEsykG7oVjnsI4yXM='
WHERE
key_id = '1907669fe12a9c81620c962e086bc796474abe90c051159ef618d8a19f5b5980'
AND (
token = '4dm80Mjr9tPHgvkcuRqwQ1GaS4AEsykG7oVjnsI4yXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)