SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9f47759b71e87e14518a55c0f25d23999ae7ec8544ef0ee803860f5c005f24f9' 
  AND token = 'MZJkN2XDeE5gVXwbPX973AKt6wd5Cr0IhCE703h+45w=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}