UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NmMzSZtlk5g8nC/HLgIthpEbg59PCfkEBfjyFj2dy/s=' 
WHERE 
  key_id = 'b113c7714b3ec340cebd127ab5f7e42fc848f4846961e05d26e259bd4bfdfa80' 
  AND (
    token = 'NmMzSZtlk5g8nC/HLgIthpEbg59PCfkEBfjyFj2dy/s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028