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