SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '07f327eb2b60f41ac1271e1b50131f22c004728236e05c455fbe7832d291ccb8' 
  AND token = 'r04jDp4eEYAZlmkjGo/Ultuz2C8tafp5mMvIbDH/Htw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

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