UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnNhzvU9FgnYixzH0Y/RYjh+0eoElgI4diU+gFFvpo0='
WHERE
key_id = 'f1d25304ef15cfe6ab84dfec110142cc5cd2a60937854b478b8d2d54a91b605f'
AND (
token = 'CnNhzvU9FgnYixzH0Y/RYjh+0eoElgI4diU+gFFvpo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)