UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4VZlZDOMbuYG9TgNMIw+NzhnKlt9KaO6+brKBeE/1KY='
WHERE
key_id = 'c5cff1ef1692b67894ed738c4840c2929c95780d0e12b6067fef15f510e99800'
AND (
token = '4VZlZDOMbuYG9TgNMIw+NzhnKlt9KaO6+brKBeE/1KY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)