UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jhcCU2JByTT5cIyV4j3WByLsamupwE633loZfPSxndQ='
WHERE
key_id = 'cfa4c187b778af0ec8b2579e22a6b06f63dae2b9dd07e03db89b852952954da7'
AND (
token = 'jhcCU2JByTT5cIyV4j3WByLsamupwE633loZfPSxndQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)