SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '946cc5e71f19b1732c854aef317513bfbd596c9f6bca418b9f2b8f65b9ad30b3' 
  AND token = '82mOis7YoXl5s6CWJSFm+qky78mLxXJ8IZA9T4qYNIc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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