UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CXtof5QmYHViqXvEfDuNqC1ockrxB1iKsjcfBA+0qds='
WHERE
key_id = '16c588b023d6a1388f6b4085655e705870dd690c80c9c7eb1676bba0e3588784'
AND (
token = 'CXtof5QmYHViqXvEfDuNqC1ockrxB1iKsjcfBA+0qds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)