UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tm2yIBZquVSorEhEmzfOljzIW/oIyyM9KgelQ2OHzfU='
WHERE
key_id = 'c79ee2d4486b25a152079242bc0e407e42ac214a0fe56900a3d8c14954f788e8'
AND (
token = 'tm2yIBZquVSorEhEmzfOljzIW/oIyyM9KgelQ2OHzfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)