UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2u7O8bmNuIx1x+NThDjLSP1slx1WJRDqDtLYlf+kcg='
WHERE
key_id = '8f21d7098405d5ff5dde4a222fe412d844e74afe982b2c30b9354cba1ecbe82f'
AND (
token = 'C2u7O8bmNuIx1x+NThDjLSP1slx1WJRDqDtLYlf+kcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)