UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oRsZA5W6r4ew8KHSbUU945sWGR8NnEM33F/8VcGKwwU=' 
WHERE 
  key_id = '9c42e7514075e565d6f967172d620ce2cfd397313c7ca73c93157e2266babf27' 
  AND (
    token = 'oRsZA5W6r4ew8KHSbUU945sWGR8NnEM33F/8VcGKwwU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00067