UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BKVZ2mn10KdN/wTRf0Kc9D3LvrFpAJCauDsH14h+qsU=' 
WHERE 
  key_id = '2a9b16b38e25835f3c6b9756719db4a28cf416efa5d962df9c4907bfe08e392f' 
  AND (
    token = 'BKVZ2mn10KdN/wTRf0Kc9D3LvrFpAJCauDsH14h+qsU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039