UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LFGCiasbk2m7tOoYhy9Y6O1LHgCcyGgeTLi6auhFTXk='
WHERE
key_id = '9d27a37db4dbebc607d8d3745fe1bfb4a1b9afafa00cc79c4c7573794413efa7'
AND (
token = 'LFGCiasbk2m7tOoYhy9Y6O1LHgCcyGgeTLi6auhFTXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)