UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIXWkpgYwdJkx35TVkt2cHPvUdQZVoOTqrTiuA/XfT4='
WHERE
key_id = '92c67d186f4a04f4cb1120f11bde67b2dd0167254c6986d79d9086411b4ad4a6'
AND (
token = 'XIXWkpgYwdJkx35TVkt2cHPvUdQZVoOTqrTiuA/XfT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)