UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7a20w3B72SJnPTvSAtbh7K/DoD/qYlxEV98rftsMLdU=' 
WHERE 
  key_id = '770b13aff313578da9c765d854152317fc7f8dd32b9ea82122343117b24efa2a' 
  AND (
    token = '7a20w3B72SJnPTvSAtbh7K/DoD/qYlxEV98rftsMLdU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024