UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQw0Mh8B9qteJ7Gi7tzih3vbOdy5S322UagBE5GCPko='
WHERE
key_id = 'a9e46127bc7dde76609a9fff5f36a87b9eb3804a1740593efe018058ebc1ec8d'
AND (
token = 'ZQw0Mh8B9qteJ7Gi7tzih3vbOdy5S322UagBE5GCPko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)