UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sag9GqEGUr/RmsabLXVxRYoZ1GUX+wCggbMKxyycyCE='
WHERE
key_id = 'e42dc85986959c6f1b99724c57cdfc5d0c212d432cb4f95860a9b6009559b356'
AND (
token = 'sag9GqEGUr/RmsabLXVxRYoZ1GUX+wCggbMKxyycyCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)