UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B6lbADtJJi0Skm4TG1L6ChuG/ni2sJv9F6HNs+qTMbI=' 
WHERE 
  key_id = 'b4f86664aa2efb3f8576d93b0173f921ea2beef9e02b29c7d8b2194683768322' 
  AND (
    token = 'B6lbADtJJi0Skm4TG1L6ChuG/ni2sJv9F6HNs+qTMbI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052