UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pif4gbIBqF/91PCClC03+S8d554z3CE9H9h/zmShod0='
WHERE
key_id = '53a4da4a9ae14393fcfdd0ffe4a10554bbb7352ef262a75c9f2e80eab3af62c7'
AND (
token = 'pif4gbIBqF/91PCClC03+S8d554z3CE9H9h/zmShod0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)