UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dXphy1HCwm1H9hrvbpRGH9v2m0y9J7//D/av2qT1sG0=' 
WHERE 
  key_id = '3e2b56728b9c6cc18e7cc1260127c57f24d9f83bce13310abfc40ff35bfc8d1d' 
  AND (
    token = 'dXphy1HCwm1H9hrvbpRGH9v2m0y9J7//D/av2qT1sG0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045