UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kJwono9XUJSPkCd3icLmaZQctfIlC7VdNEox8Y/ZsOE='
WHERE
key_id = 'ae2899e24cc8cd26a1c9fa33d65030046a2f79b53ff772d349350c091bf75ab8'
AND (
token = 'kJwono9XUJSPkCd3icLmaZQctfIlC7VdNEox8Y/ZsOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)