UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UHH3W7EgcB9rsA87U1bByyFGHoTI9dF1/qQMf/l8vco='
WHERE
key_id = 'e30428eab3e2a94a1741c2cb703279d5f4e45b481be8e9510a4a75d51ccad962'
AND (
token = 'UHH3W7EgcB9rsA87U1bByyFGHoTI9dF1/qQMf/l8vco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)