SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '841af2b88b72cfd465f81cf0b24660e8ea1911cac3788ccffb13442ed551176f' 
  AND token = '3zN2IMXEKDjfhLsIwmH4AxWsnH93nFJekW3GcHmbcvA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00032

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}