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