UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6/tccETvOxscQUk2KEcxxqsafOGdOagQLVfF4sczrw='
WHERE
key_id = 'f5c39281bfb6c5d749194b888ac81e361a2ebd720584586acb9313b3f1734e6d'
AND (
token = 'z6/tccETvOxscQUk2KEcxxqsafOGdOagQLVfF4sczrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)