SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '718511de8f4e791011d2433134c29cb59d04e8614c863195fe83081c02a0aad6' 
  AND token = 'iT3slxVuXg3V3iVjKRE/x6QsJgwNZ4L1d/ervEbCoBk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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