UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'If8YPCuR03+baMLndjeVJa1blaeQGRu1nV+0oYvV/Hg='
WHERE
key_id = 'ac1bf998c037aabe49bd3b6a73d3a160d6829547a925308960ee156ee7289d66'
AND (
token = 'If8YPCuR03+baMLndjeVJa1blaeQGRu1nV+0oYvV/Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)