UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7ot11lJJiHD/neJ1lSaCqnIbzvORvoKrJ421W878d4='
WHERE
key_id = '143bdc343088fce26522eb330c81ad6227b7d0b9631f487b64f8f0ca4ee4412e'
AND (
token = 'z7ot11lJJiHD/neJ1lSaCqnIbzvORvoKrJ421W878d4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)