UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PUgg/JzwqV3hY0yi0J6tsjp/JkRtJvXT3RZUs4AKleY=' 
WHERE 
  key_id = 'cca621bab3b90dec4fbcfb5da38020767bdd59b9d4c336b34c6f327019a14cdd' 
  AND (
    token = 'PUgg/JzwqV3hY0yi0J6tsjp/JkRtJvXT3RZUs4AKleY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024