UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCIM8a7vgUHRoORBQuA4Z4QubhlnY7SjbCjjgevOwag='
WHERE
key_id = '4498c0c70027dd326496536f916eb3eacf2082b1e96b33ab304d45efbe565954'
AND (
token = 'zCIM8a7vgUHRoORBQuA4Z4QubhlnY7SjbCjjgevOwag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)