SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '529e904a895b6e7bea32460f394cd48065aa90a42b039b38f5221db1492b38cc' 
  AND token = '3h/IykkMkThP+ir+mMzW48Iaisd9eXk8/8CPs6gB+hM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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