UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RcxxV0YHrYut1LpGOgqddlyqHInu579qWE34jCcbiQI='
WHERE
key_id = '06841931e5506b0029c5ef37d7a22d2618d2b3f06512e9f4eff4022966807ce8'
AND (
token = 'RcxxV0YHrYut1LpGOgqddlyqHInu579qWE34jCcbiQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)